﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Copy Database</title>
<meta name="GENERATOR" content="WinCHM">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

</head>

<body>
<P><A 
href="http://lichao.net/eblog/how-easily-to-move-oracle-data-from-one-machine-to-another-20060626.html">http://lichao.net/eblog/how-easily-to-move-oracle-data-from-one-machine-to-another-20060626.html</A></P>
<P 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 13px 0px; WORD-SPACING: 0px; FONT: 12px/21px 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(68,68,68); TEXT-INDENT: 0px; PADDING-TOP: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: justify; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"><STRONG 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: 'Lucida Grande', 'Lucida Sans', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif">Step 
1:<SPAN class=Apple-converted-space>&nbsp;Stop the Oracle service<BR></SPAN></STRONG>Stop the Oracle 
service on the new server to make sure everything smooth. On Windows 2003 
server, just go into the Service console of Administrative tools, and click Stop 
button for Oracle service.<BR><STRONG 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: 'Lucida Grande', 'Lucida Sans', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif">Step 
2:<SPAN class=Apple-converted-space>&nbsp;<BR></SPAN></STRONG>Make sure the oracle 
service on both machines are similar. Like the existing one called MYDATA then 
the new one should be better called MYDATA too. If not, then create an Oralce 
service with the same name on the new server. I am not sure whether this step is 
mandatory or not. But to have less trouble, why not we keep them identical.</P>
<P 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 13px 0px; WORD-SPACING: 0px; FONT: 12px/21px 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(68,68,68); TEXT-INDENT: 0px; PADDING-TOP: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: justify; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"><STRONG 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: 'Lucida Grande', 'Lucida Sans', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif">Step 
3:<SPAN class=Apple-converted-space>&nbsp;<BR></SPAN></STRONG>Copy two files from the Oracle 
application folder to the same folder on the new server. <BR>These two files are 
SPFILE and Password files. In my case, they are<BR>    
              
          <STRONG 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: 'Lucida Grande', 'Lucida Sans', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif">C:\oracle\ora92\database\SPFILEMYDATA.ora</STRONG><BR><STRONG 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: 'Lucida Grande', 'Lucida Sans', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif">C:\oracle\ora92\database\PWDMYDATA.ora</STRONG></P>
<P 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 13px 0px; WORD-SPACING: 0px; FONT: 12px/21px 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(68,68,68); TEXT-INDENT: 0px; PADDING-TOP: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: justify; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"><STRONG 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: 'Lucida Grande', 'Lucida Sans', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif">Step 
4:<SPAN class=Apple-converted-space>&nbsp;<BR></SPAN></STRONG>Copy data folder to new server. 
<BR>There are a lot of control files in this folder whose name same as the 
Oracle service name. <BR>    
                
    And it should be under the folder of<STRONG 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: 'Lucida Grande', 'Lucida Sans', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif">oradata</STRONG>. 
In my case I copied the whole folder of<SPAN 
class=Apple-converted-space>&nbsp;</SPAN><STRONG 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: 'Lucida Grande', 'Lucida Sans', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif">c:\oracle\oradata\MYDATA</STRONG><SPAN 
class=Apple-converted-space>&nbsp;</SPAN>to the directory of c:\oracle\oradata\ 
on the new server.</P>
<P 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 13px 0px; WORD-SPACING: 0px; FONT: 12px/21px 'Lucida Grande', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif; TEXT-TRANSFORM: none; COLOR: rgb(68,68,68); TEXT-INDENT: 0px; PADDING-TOP: 0px; WHITE-SPACE: normal; LETTER-SPACING: normal; BACKGROUND-COLOR: rgb(255,255,255); TEXT-ALIGN: justify; orphans: 2; widows: 2; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px"><STRONG 
style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-TOP: 0px; FONT-FAMILY: 'Lucida Grande', 'Lucida Sans', 'Lucida Sans Unicode', Verdana, Helvetica, Arial, sans-serif">Step 
5:<SPAN class=Apple-converted-space>&nbsp;<BR></SPAN></STRONG>re-start the oracle 
service on the new server. Tested, and it was successful.</P></body>
</html>
